CREATE DATABASE `bdministerio` ;

CREATE TABLE `region` (
  `idreg` int(2) NOT NULL auto_increment,
  `regdes` char(40) character set latin1 collate latin1_spanish_ci NOT NULL,
  PRIMARY KEY  (`idreg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `departamento` (
  `depto_id` int(2) NOT NULL auto_increment,
  `departamento` varchar(20) character set latin1 collate latin1_spanish_ci default NULL,
  `idreg` int(2) NOT NULL,
  PRIMARY KEY  (`depto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


ALTER TABLE `departamento`
  ADD CONSTRAINT `fk_idregdpto` FOREIGN KEY (`idreg`) REFERENCES `region` (`idreg`) ON UPDATE CASCADE;

CREATE TABLE `municipios` (
  `id_mun` int(3) NOT NULL auto_increment,
  `municipio` varchar(30) character set latin1 collate latin1_spanish_ci default NULL,
  `depto_id` int(2) NOT NULL,
  PRIMARY KEY  (`id_mun`),
  KEY `fk_depto_id` (`depto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `municipios`
  ADD CONSTRAINT `fk_depto_id` FOREIGN KEY (`depto_id`) REFERENCES `departamento` (`depto_id`) ON UPDATE CASCADE;

CREATE TABLE `sibasi` (
  `sib` int(2) NOT NULL auto_increment,
  `nomsibasi` char(35) character set latin1 collate latin1_spanish_ci default NULL,
  `idreg` int(2) default NULL,
  PRIMARY KEY  (`sib`),
  KEY `fk_idreg` (`idreg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `sibasi`
  ADD CONSTRAINT `fk_idreg` FOREIGN KEY (`idreg`) REFERENCES `region` (`idreg`) ON UPDATE CASCADE;

CREATE TABLE `tipo_establecimiento` (
  `id_tipo` int(2) NOT NULL auto_increment,
  `tipo` char(50) character set latin1 collate latin1_spanish_ci default NULL,
  `descripcion` varchar(25) character set latin1 collate latin1_spanish_ci NOT NULL,
  PRIMARY KEY  (`id_tipo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `establecimiento` (
  `idest` int(4) NOT NULL auto_increment,
  `sib` int(2) default NULL,
  `id_tipo` int(2) default NULL,
  `estable` varchar(60) character set latin1 collate latin1_spanish_ci default NULL,
  `id_mun` int(3) default NULL,
  PRIMARY KEY  (`idest`),
  KEY `fk_id_tipo` (`id_tipo`),
  KEY `fk_sib` (`sib`),
  KEY `fk_id_mun` (`id_mun`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `establecimiento`
  ADD CONSTRAINT `fk_id_mun` FOREIGN KEY (`id_mun`) REFERENCES `municipios` (`id_mun`) ON UPDATE CASCADE;
ALTER TABLE `establecimiento`
  ADD CONSTRAINT `fk_id_tipo` FOREIGN KEY (`id_tipo`) REFERENCES `tipo_establecimiento` (`id_tipo`) ON UPDATE CASCADE;
ALTER TABLE `establecimiento`
  ADD CONSTRAINT `fk_sib` FOREIGN KEY (`sib`) REFERENCES `sibasi` (`sib`) ON UPDATE CASCADE;

CREATE TABLE `rol_usuario` (
  `id_rol` int(2) NOT NULL auto_increment,
  `rol` char(20) character set latin1 collate latin1_spanish_ci NOT NULL,
  PRIMARY KEY  (`id_rol`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `usuarios` (
  `id_usuario` int(11) NOT NULL auto_increment,
  `nombre` char(20) character set latin1 collate latin1_spanish_ci default NULL,
  `apellido` char(20) character set latin1 collate latin1_spanish_ci default NULL,
  `usuario_login` char(15) character set latin1 collate latin1_spanish_ci default NULL,
  `usuario_password` char(15) character set latin1 collate latin1_spanish_ci default NULL,
  `idest` int(4) NOT NULL,
  `id_rol` int(2) NOT NULL,
  PRIMARY KEY  (`id_usuario`),
  KEY `fk_idest` (`idest`),
  KEY `fk_id_rol` (`id_rol`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


ALTER TABLE `usuarios`
  ADD CONSTRAINT `fk_idest` FOREIGN KEY (`idest`) REFERENCES `establecimiento` (`idest`) ON UPDATE CASCADE;
ALTER TABLE `usuarios`
  ADD CONSTRAINT `fk_id_rol` FOREIGN KEY (`id_rol`) REFERENCES `rol_usuario` (`id_rol`) ON UPDATE CASCADE;


CREATE TABLE `poblacion` (
  `id_mun` int(3) NOT NULL,
  `anio` int(4) NOT NULL,
  `m1a` int(5) default NULL,
  `1_4` int(5) default NULL,
  `5_9` int(5) default NULL,
  `10_14` int(5) default NULL,
  `15_19` int(5) default NULL,
  `20_59` int(5) default NULL,
  `60+` int(5) default NULL,
  `mef10_14` int(5) default NULL,
  `mef15_19` int(5) default NULL,
  `mef20_49` int(5) default NULL,
  );

ALTER TABLE `poblacion`
  ADD CONSTRAINT `fk_id_mun_pob` FOREIGN KEY (`id_mun`) REFERENCES `municipios` (`id_mun`) ON UPDATE CASCADE;


CREATE TABLE `reg_inmunoa` (
  `id_registro1` int(11) NOT NULL auto_increment,
  `recurso` varchar(20) character set latin1 collate latin1_spanish_ci default NULL,
  `programa` varchar(40) character set latin1 collate latin1_spanish_ci NOT NULL,
  `id_mun` int(3) NOT NULL,
  `areaur` int(11) default NULL,
  `arearu` int(11) default NULL,
  `sexom` int(11) default NULL,
  `sexof` int(11) default NULL,
  `bcgm1` int(11) default NULL,
  `rotm6d1` int(11) default NULL,
  `rotm6d2` int(11) default NULL,
  `pentam1d1` int(11) default NULL,
  `pentam1d2` int(11) default NULL,
  `pentam1d3` int(11) default NULL,
  `penta1_4d1` int(11) default NULL,
  `penta1_4d2` int(11) default NULL,
  `penta1_4d3` int(11) default NULL,
  `apm1d1` int(11) default NULL,
  `apm1d2` int(11) default NULL,
  `apm1d3` int(11) default NULL,
  `ap1_4d1` int(11) default NULL,
  `ap1_4d2` int(11) default NULL,
  `ap1_4d3` int(11) default NULL,
  `ap1_4r1` int(11) default NULL,
  `ap1_4r2` int(11) default NULL,
  `dpt1_4r1` int(11) default NULL,
  `dpt1_4r2` int(11) default NULL,
  `spr1` int(11) default NULL,
  `spr2_3` int(11) default NULL,
  `spr4d1` int(11) default NULL,
  `spr4d2` int(11) default NULL,
  `dtped2m_9d1` int(11) default NULL,
  `dtped2m_9d2` int(11) default NULL,
  `dtped2m_9d3` int(11) default NULL,
  `dtped2m_9r1` int(11) default NULL,
  `dtped2m_9r2` int(11) default NULL,
  PRIMARY KEY  (`id_registro1`),
  KEY `fk_rega_id_mun` (`id_mun`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `reg_inmunoa`
  ADD CONSTRAINT `fk_rega_id_mun` FOREIGN KEY (`id_mun`) REFERENCES `municipios` (`id_mun`) ON UPDATE CASCADE;


CREATE TABLE `tabuladorinmunizacionesa` (
  `id_registro1` int(11) NOT NULL,
  `fecha_registro` date default NULL,
  `fecha_ingreso` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `id_usuario` int(11) default NULL,
  `idest` int(4) NOT NULL,
  KEY `fk_id_registro1` (`id_registro1`),
  KEY `fktaba_id_usuario` (`id_usuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tabuladorinmunizacionesa`
  ADD CONSTRAINT `fktaba_id_usuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON UPDATE CASCADE;
ALTER TABLE `tabuladorinmunizacionesa`
  ADD CONSTRAINT `fk_id_registro1` FOREIGN KEY (`id_registro1`) REFERENCES `reg_inmunoa` (`id_registro1`) ON UPDATE CASCADE;
ALTER TABLE `tabuladorinmunizacionesa`
 ADD CONSTRAINT `fktabinma_id_est` FOREIGN KEY (`idest`) REFERENCES `establecimiento` (`idest`) ON UPDATE CASCADE,


CREATE TABLE `reg_inmunob` (
  `id_registro2` int(11) NOT NULL auto_increment,
  `programa` varchar(30) character set latin1 collate latin1_spanish_ci default NULL,
  `recurso` varchar(20) character set latin1 collate latin1_spanish_ci default NULL,
  `id_mun` int(3) default NULL,
  `areaurb` int(11) default NULL,
  `arearub` int(11) default NULL,
  `sexomb` int(11) default NULL,
  `sexofb` int(11) default NULL,
  `toxteme10_19d1` int(11) default NULL,
  `toxteme10_19d2` int(11) default NULL,
  `toxteme10_19d3` int(11) default NULL,
  `toxteme10_19d4` int(11) default NULL,
  `toxteme10_19d5` int(11) default NULL,
  `toxteme10_19r` int(11) default NULL,
  `toxteme20_49d1` int(11) default NULL,
  `toxteme20_49d2` int(11) default NULL,
  `toxteme20_49d3` int(11) default NULL,
  `toxteme20_49d4` int(11) default NULL,
  `toxteme20_49d5` int(11) default NULL,
  `toxteme20_49r` int(11) default NULL,
  `tdmne10_19d1` int(11) default NULL,
  `tdmne10_19d2` int(11) default NULL,
  `tdmne10_19d3` int(11) default NULL,
  `tdmne10_19d4` int(11) default NULL,
  `tdmne10_19d5` int(11) default NULL,
  `tdmne10_19r` int(11) default NULL,
  `tdmne20_49d1` int(11) default NULL,
  `tdmne20_49d2` int(11) default NULL,
  `tdmne20_49d3` int(11) default NULL,
  `tdmne20_49d4` int(11) default NULL,
  `tdmne20_49d5` int(11) default NULL,
  `tdmne20_49r` int(11) default NULL,
  `tdmne50_59d1` int(11) default NULL,
  `tdmne50_59d2` int(11) default NULL,
  `tdmne50_59d3` int(11) default NULL,
  `tdmne50_59d4` int(11) default NULL,
  `tdmne50_59d5` int(11) default NULL,
  `tdmne50_59r` int(11) default NULL,
  `tdmne60d1` int(11) default NULL,
  `tdmne60d2` int(11) default NULL,
  `tdmne60d3` int(11) default NULL,
  `tdmne60d4` int(11) default NULL,
  `tdmne60d5` int(11) default NULL,
  `tdmne60r` int(11) default NULL,
  `tdh10_19d1` int(11) default NULL,
  `tdh10_19d2` int(11) default NULL,
  `tdh10_19d3` int(11) default NULL,
  `tdh10_19d4` int(11) default NULL,
  `tdh10_19d5` int(11) default NULL,
  `tdh10_19r` int(11) default NULL,
  `tdh20_59d1` int(11) default NULL,
  `tdh20_59d2` int(11) default NULL,
  `tdh20_59d3` int(11) default NULL,
  `tdh20_59d4` int(11) default NULL,
  `tdh20_59d5` int(11) default NULL,
  `tdh20_59r` int(11) default NULL,
  `tdh60d1` int(11) default NULL,
  `tdh60d2` int(11) default NULL,
  `tdh60d3` int(11) default NULL,
  `tdh60d4` int(11) default NULL,
  `tdh60d5` int(11) default NULL,
  `tdh60r` int(11) default NULL,
  PRIMARY KEY  (`id_registro2`),
  KEY `fk_regb_id_mun` (`id_mun`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `reg_inmunob`
  ADD CONSTRAINT `fk_regb_id_mun` FOREIGN KEY (`id_mun`) REFERENCES `municipios` (`id_mun`) ON UPDATE CASCADE;


CREATE TABLE `tabuladorinmunizacionesb` (
  `id_registro2` int(11) NOT NULL,
  `fecha_registro` date default NULL,
  `fecha_ingreso` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `id_usuario` int(11) default NULL,
  `idest` int(4) NOT NULL,
  KEY `fk_id_registro2` (`id_registro2`),
  KEY `fktabb_id_usuario` (`id_usuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tabuladorinmunizacionesb`
  ADD CONSTRAINT `fktabb_id_usuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON UPDATE CASCADE;
ALTER TABLE `tabuladorinmunizacionesb`
  ADD CONSTRAINT `fk_id_registro2` FOREIGN KEY (`id_registro2`) REFERENCES `reg_inmunob` (`id_registro2`) ON UPDATE CASCADE;

CREATE TABLE `reg_inmunoc` (
  `id_registro3` int(11) NOT NULL auto_increment,
  `recurso` varchar(20) character set latin1 collate latin1_spanish_ci default NULL,
  `id_mun` int(11) default NULL,
  `areaur` int(11) default NULL,
  `arearu` int(11) default NULL,
  `sexom` int(11) default NULL,
  `sexof` int(11) default NULL,
  `dptm1` int(11) default NULL,
  `dptm1_4` int(11) default NULL,
  `dtped2m_9` int(11) default NULL,
  `td10` int(11) default NULL,
  `apm1` int(11) default NULL,
  `ap1_4` int(11) default NULL,
  `ap5_14` int(11) default NULL,
  `sprsr1_4` int(11) default NULL,
  `sprsr5_14` int(11) default NULL,
  `sprsr15` int(11) default NULL,
  `hepbgrd1` int(11) default NULL,
  `hepbgrd2` int(11) default NULL,
  `hepbgrd3` int(11) default NULL,
  `inf6_11md1` int(11) default NULL,
  `inf6_11md2` int(11) default NULL,
  `inf12_23pvd1` int(11) default NULL,
  `inf12_23pvd2` int(11) default NULL,
  `inf12_23dar` int(11) default NULL,
  `infa60` int(11) default NULL,
  `infts` int(11) default NULL,
  `afa1_4` int(11) default NULL,
  `afa5` int(11) default NULL,
  PRIMARY KEY  (`id_registro3`),
  KEY `fk_regc_id_mun` (`id_mun`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `reg_inmunoc`
  ADD CONSTRAINT `fk_regc_id_mun` FOREIGN KEY (`id_mun`) REFERENCES `municipios` (`id_mun`) ON UPDATE CASCADE;


CREATE TABLE `tabuladorinmunizacionesc` (
  `id_registro3` int(11) NOT NULL,
  `fecha_registro` date default NULL,
  `fecha_ingreso` timestamp NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `id_usuario` int(11) default NULL,
  `idest` int(4) NOT NULL,
  KEY `fk_id_registro3` (`id_registro3`),
  KEY `fktabc_id_usuario` (`id_usuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tabuladorinmunizacionesc`
  ADD CONSTRAINT `fktabc_id_usuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON UPDATE CASCADE;
ALTER TABLE `tabuladorinmunizacionesc`
  ADD CONSTRAINT `fk_id_registro3` FOREIGN KEY (`id_registro3`) REFERENCES `reg_inmunoc` (`id_registro3`) ON UPDATE CASCADE;

CREATE TABLE `reg_lepra` (
  `id_registro5` int(11) NOT NULL auto_increment,
  `sexom` int(11) default NULL,
  `sexof` int(11) default NULL,
  `clma1` int(11) default NULL,
  `clma2` int(11) default NULL,
  `clma3` int(11) default NULL,
  `clma4` int(11) default NULL,
  `clmb1` int(11) default NULL,
  `clmb2` int(11) default NULL,
  `clmb3` int(11) default NULL,
  `clmb4` int(11) default NULL,
  `clmc1` int(11) default NULL,
  `clmc2` int(11) default NULL,
  `clmc3` int(11) default NULL,
  `clmc4` int(11) default NULL,
  `clpa1` int(11) default NULL,
  `clpa2` int(11) default NULL,
  `clpa3` int(11) default NULL,
  `clpa4` int(11) default NULL,
  `clpb1` int(11) default NULL,
  `clpb2` int(11) default NULL,
  `clpb3` int(11) default NULL,
  `clpb4` int(11) default NULL,
  `cil` int(11) default NULL,
  `cpl` int(11) default NULL,
  `dgi` int(11) default NULL,
  `dgii` int(11) default NULL,
  `dgiii` int(11) default NULL,
  `vdcc` int(11) default NULL,
  PRIMARY KEY  (`id_registro5`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



CREATE TABLE `tabuladorlepra` (
  `id_registro5` int(11) NOT NULL,
  `fecha_registro` date default NULL,
  `fecha_ingreso` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `id_usuario` int(11) default NULL,
  `idest` int(4) NOT NULL,
  KEY `fk_id_registro5` (`id_registro5`),
  KEY `fktablep_id_usuario` (`id_usuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


ALTER TABLE `tabuladorlepra`
  ADD CONSTRAINT `fktablep_id_usuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON UPDATE CASCADE;
ALTER TABLE `tabuladorlepra`
  ADD CONSTRAINT `fk_id_registro5` FOREIGN KEY (`id_registro5`) REFERENCES `reg_lepra` (`id_registro5`) ON UPDATE CASCADE;

CREATE TABLE `reg_rabia` (
  `id_registro4` int(11) NOT NULL auto_increment,
  `sexom` int(11) default NULL,
  `sexof` int(11) default NULL,
  `e1` int(11) default NULL,
  `e2` int(11) default NULL,
  `e3` int(11) default NULL,
  `e4` int(11) default NULL,
  `e5` int(11) default NULL,
  `e6` int(11) default NULL,
  `e7` int(11) default NULL,
  `e8` int(11) default NULL,
  `e9` int(11) default NULL,
  `proc_urbano` int(11) default NULL,
  `proc_rural` int(11) default NULL,
  `tiplesa1` int(11) default NULL,
  `tiplesa2` int(11) default NULL,
  `tiplesa3` int(11) default NULL,
  `tiplesb1` int(11) default NULL,
  `tiplesb2` int(11) default NULL,
  `tiplesb3` int(11) default NULL,
  `tiplesb4` int(11) default NULL,
  `tiplesb5` int(11) default NULL,
  `tiplesb6` int(11) default NULL,
  `tiplesb7` int(11) default NULL,
  `tiplesb8` int(11) default NULL,
  `tiplesb9` int(11) default NULL,
  `tipag1` int(11) default NULL,
  `tipag2` int(11) default NULL,
  `tipag3` int(11) default NULL,
  `tipag4` int(11) default NULL,
  `tipag5` int(11) default NULL,
  `tratobs1` int(11) default NULL,
  `tratobs2` int(11) default NULL,
  `tratobs3` int(11) default NULL,
  `tratobs4` int(11) default NULL,
  `tratobs5` int(11) default NULL,
  `tratpvcrl` int(11) default NULL,
  `tratpvcc` int(11) default NULL,
  `tratprexcrl` int(11) default NULL,
  `tratprexcc` int(11) default NULL,
  `tratpostexcrl` int(11) default NULL,
  `tratpostexcc` int(11) default NULL,
  `totdracrl` int(11) default NULL,
  `totdracc` int(11) default NULL,
  `crldrec` int(11) default NULL,
  `crldap` int(11) default NULL,
  `ccdrec` int(11) default NULL,
  `ccdap` int(11) default NULL,
  `nusa` int(11) default NULL,
  `ce1` int(11) default NULL,
  `ce2` int(11) default NULL,
  `ce3` int(11) default NULL,
  `ce4` int(11) default NULL,
  `rpv1` int(11) default NULL,
  `rpv2` int(11) default NULL,
  PRIMARY KEY  (`id_registro4`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `tabuladorrabia` (
  `id_registro4` int(11) NOT NULL,
  `fecha_registro` date default NULL,
  `fecha_ingreso` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `id_usuario` int(11) default NULL,
  `idest` int(4) NOT NULL,
  KEY `fk_id_registro4` (`id_registro4`),
  KEY `fktabrab_id_usuario` (`id_usuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tabuladorrabia`
  ADD CONSTRAINT `fktabrab_id_usuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON UPDATE CASCADE;
ALTER TABLE `tabuladorrabia`
  ADD CONSTRAINT `fk_id_registro4` FOREIGN KEY (`id_registro4`) REFERENCES `reg_rabia` (`id_registro4`) ON UPDATE CASCADE;

CREATE TABLE `reg_tuberculosis` (
  `id_registro6` int(11) NOT NULL auto_increment,
  `tsri` int(11) default NULL,
  `sri1` int(11) default NULL,
  `sri2` int(11) default NULL,
  `ctc` int(11) default NULL,
  `ctp` int(11) default NULL,
  `cte` int(11) default NULL,
  `ctm` int(11) default NULL,
  `ptpd` int(11) default NULL,
  `pted` int(11) default NULL,
  `ptvta` int(11) default NULL,
  `ctvat` int(11) default NULL,
  `cectf` int(11) default NULL,
  `cptp` int(11) default NULL,
  `cmiq` int(11) default NULL,
  `ctpv` int(11) default NULL,
  `vdptb` int(11) default NULL,
  PRIMARY KEY  (`id_registro6`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `tabuladortuberculosis` (
  `id_registro6` int(11) NOT NULL,
  `fecha_registro` date default NULL,
  `fecha_ingreso` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `id_usuario` int(11) default NULL,
  `idest` int(4) NOT NULL,
  KEY `fk_id_registro6` (`id_registro6`),
  KEY `fktabtub_id_usuario` (`id_usuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tabuladortuberculosis`
  ADD CONSTRAINT `fktabtub_id_usuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON UPDATE CASCADE;
ALTER TABLE `tabuladortuberculosis`
  ADD CONSTRAINT `fk_id_registro6` FOREIGN KEY (`id_registro6`) REFERENCES `reg_tuberculosis` (`id_registro6`) ON UPDATE CASCADE;

CREATE TABLE `reg_sida` (
  `id_registro7` int(11) NOT NULL auto_increment,
  `cnv1` int(11) default NULL,
  `cnv2a` int(11) default NULL,
  `cnv2b` int(11) default NULL,
  `cnv3` int(11) default NULL,
  `cnv4` int(11) default NULL,
  `cnv5` int(11) default NULL,
  `cnv6` int(11) default NULL,
  `cns1` int(11) default NULL,
  `cns2a` int(11) default NULL,
  `cns2b` int(11) default NULL,
  `cns3` int(11) default NULL,
  `cns4` int(11) default NULL,
  `cns5` int(11) default NULL,
  `cns6` int(11) default NULL,
  `cstbp1` int(11) default NULL,
  `cstbp2a` int(11) default NULL,
  `cstbp2b` int(11) default NULL,
  `cstbp3` int(11) default NULL,
  `cstbp4` int(11) default NULL,
  `cstbp5` int(11) default NULL,
  `cstbp6` int(11) default NULL,
  `ptai1` int(11) default NULL,
  `ptai2a` int(11) default NULL,
  `ptai2b` int(11) default NULL,
  `ptai3` int(11) default NULL,
  `ptai4` int(11) default NULL,
  `ptai5` int(11) default NULL,
  `ptai6` int(11) default NULL,
  `pata` int(11) default NULL,
  `qtbv1` int(11) default NULL,
  `qtbv2` int(11) default NULL,
  `csi1` int(11) default NULL,
  `csi2` int(11) default NULL,
  `palpevs` int(11) default NULL,
  PRIMARY KEY  (`id_registro7`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `tabuladorsida` (
  `id_registro7` int(11) NOT NULL,
  `fecha_registro` date default NULL,
  `fecha_ingreso` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `id_usuario` int(11) default NULL,
  `idest` int(4) NOT NULL,
  KEY `fk_id_registro7` (`id_registro7`),
  KEY `fktabsid_id_usuario` (`id_usuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tabuladorsida`
  ADD CONSTRAINT `fktabsid_id_usuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id_usuario`) ON UPDATE CASCADE;
ALTER TABLE `tabuladorsida`
  ADD CONSTRAINT `fk_id_registro7` FOREIGN KEY (`id_registro7`) REFERENCES `reg_sida` (`id_registro7`) ON UPDATE CASCADE;


